package com.jkoss.dao.jy;

import com.jkoss.pojo.jy.Interview;
import com.jkoss.pojo.jy.InterviewExample;
import com.jkoss.tool.Page;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;
import org.springframework.web.bind.annotation.RequestMapping;

public interface InterviewMapper {
	
	@Select("select a.*,b.jygwName,c.jyname ,d.stuname ,e.clzname from t_interview a ,t_stu_cmpjob b ,t_jiuyecomps c,t_ossstu d ,t_classes e "
			+ "where  a.jygwid=b.jygwid AND b.jyid=c.jyid  and  a.ossstuid=d.ossstuid  AND  d.clzid=e.clzid")
	@ResultMap("com.jkoss.dao.jy.InterviewMapper.BaseResultMap2")
	List<Interview> listPageItv(Page<Interview> page);
	
	
	@Select("select a.*,b.jygwName,c.jyname ,d.stuname  from t_interview a ,t_stu_cmpjob b ,t_jiuyecomps c,t_ossstu d "
			+ "where  a.jygwid=b.jygwid AND b.jyid=c.jyid  and  a.ossstuid=d.ossstuid  and a.stumsid=${stumsid}")
	@ResultMap("com.jkoss.dao.jy.InterviewMapper.BaseResultMap2")
	Interview findById(@Param("stumsid") Integer stumsid);
	
    int countByExample(InterviewExample example);

    int deleteByExample(InterviewExample example);

    int deleteByPrimaryKey(Integer stumsid);

    int insert(Interview record);

    int insertSelective(Interview record);

    List<Interview> selectByExample(InterviewExample example);

    Interview selectByPrimaryKey(Integer stumsid);

    int updateByExampleSelective(@Param("record") Interview record, @Param("example") InterviewExample example);

    int updateByExample(@Param("record") Interview record, @Param("example") InterviewExample example);

    int updateByPrimaryKeySelective(Interview record);

    int updateByPrimaryKey(Interview record);

	

	
}